﻿


create table Photos (
        Id INT IDENTITY NOT NULL,
       Name NVARCHAR(255) not null,
       Url NVARCHAR(255) not null,
       Description NVARCHAR(255) not null,
       TagLine NVARCHAR(255) not null,
       IsThumbnail BIT not null,
       ProjectFk INT null,
       primary key (Id)
    )   


 alter table Photos 
        add constraint FK44AFC48A47CA2FCE 
        foreign key (ProjectFk) 
        references Projects

